Release 10.1A: OpenEdge Development:
ADM Reference
findRowWhere
Finds a row and repositions to that row.
Location: sbo.p Parameters:INPUT pcColumns AS CHARACTERFor a SmartBusinessObject (SBO), column names (comma separated); fieldname of a table in the query in the form of TBL.FLDNM or DB.TBL.FLDNM (only if qualified with db).
For a SmartDataObjects (SDO), column names (comma separated); fieldname of a table in the query in the form of RowObject.FLDNM.
If the fieldname is not qualified, it checks the tables in the TABLES property and uses the first match.
INPUT pcValues AS CHARACTERCorresponding Values (CHR(1) separated).
INPUT pcOperators AS CHARACTERThe operator (one for all columns):
- This method resolves the row reposition on the server. As a result, the SDO can no longer determine whether the row position is invalid until after the request has been executed. However, if the RebuildOnRepos property is set to TRUE, the temp-table is emptied before the request.
- The current behavior for a FIND that does not find anything when RebuildOnRepos is TRUE is to read the current batch again.
- The logic is in the
query.psuper procedure.
|
Copyright © 2005 Progress Software Corporation www.progress.com Voice: (781) 280-4000 Fax: (781) 280-4095 |